To use this script you need to open the files "Original" and "Reduce". To achieve this via Apple script, type the following two lines immediately following the line 'Tell application "FileMaker Pro"' (you may have to change the file path):
a)Open file named {"hard disk:FMP/AS examples:FileMaker Pro 2.0 Files:Original"}
b)Open file named {"hard disk:FMP/AS examples:FileMaker Pro 2.0 Files:Reduce"}
where hard disk is the name of the hard disk on which the files are resident.
This script copies a specific portion of one file into another file i.e.
1)It finds all records with a first name of Fred in the database named "Original"
2)Sorts the found set by surname
3)Counts the number of records in the found set
4)Creates a new record in a new file (the database named "reduce") for each record in the found set of the original file and transfers the data from the original file to the reduced file.
